{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Index","Patients","Patient Notes","Insurance","Billing","EmployeeInfo","Payroll","PaycheckArchive","Notes"],"not_rendered":{"charts":0,"images":40,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Index","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,4],[4,1,4,3]]}
["Willow Creek Physical Therapy"]
[]
[]
[]
[null,"Page Index"]

{"sheet":"Patients","index":1,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,6],[4,1,4,4]]}
["Willow Creek Physical Therapy"]
[]
[]
[]
[null,"Patient List",null,null,null,"Patients on File:",{"$f":"COUNT(A9:A994)","v":13}]
[]
[]
["ID #","Name","Phone","Address","D.O.B.","Email","Insurance","Doctor","Doctor Office","Doctor Phone"]
[1,"Austin Byron","406-369-4554","2334 Crab Lane","03/21/1991","austincbyron@gmail.com","Yes","Dr. Latu","Mountain Medical","801-677-2334"]
[2,"Freddy Mercury","801-334-5543","1223 Crest Dr.","03/19/1956","fred.murc@gmail.com","Yes","Dr. Christiansen","Regional Death","223-908-4455"]
[3,"Ricky Bobby","408-334-8976","1223 Victory Lane","12/25/1978","rick.bobby@gmail.com","Yes","Dr. Woods","Paralytic Recover","801-445-9089"]
[4,"Jack Black","801-556-6789","1234 D Lane","09/04/1978","jack.black@gmail.com","Yes","Dr. Richards","Mountain View","801-556-6789"]
[5,"Mr. Rogers","608-909-8897","123 Neighborhood Dr.","07/03/1958","m.rogers@gmail.com","No","Dr. Abrams","Valley Medical","509-998-7786"]
[6,"Jennifer Erickson","801-344-6789","344 Rocky Lane","11/11/1998","jenn.erickson@gmail.com","Yes","Dr. Fonseca","Rookie Medical","908-887-6657"]
[7,"Scott  Merrill","809-778-5798","210 Black Ln.","09/12/1989","scott.merrill@gmail.com","No","Dr. Mousely","Rippers Med.","887-887-1221"]
[8,"Brad Bishop","807-776-4537","334 Frost Ln.","09/12/1976","brad.bishop@gmail.com","Yes","Dr. Ferreiro","Family Medical","709-998-0876"]
[9,"Erika Thompson","801-334-5678","356 Canyon Rd.","09/29/1987","erika.thompson@gmail.com","No","Dr. Packer","Cutting Edge Med.","778-908-7764"]
[10,"Amy Renton","608-344-8756","223 Long  Beach Dr.","06/12/1979","amy.renton@gmail.com","Yes","Dr. Erikson","Meadow Regional","809-356-7890"]
[11,"Robert Sanchez","406-657-3212","345 Broken Ln.","09/23/1967","rob.sanchez@gmail.com","Yes","Dr. Christiansen","Rocky Medical","508-455-1298"]
[12,"Austin Allen","808-445-2311","456 Rocky Rd.","10/09/2000","austin.all@gmai.com","Yes","Dr. Richard","BYU Medical","801-990-3467"]
[13,"Rick James","909-344-2144","1445 Frost Ln.","12/22/1980","rick.james@gmail.com","Yes","Dr. Roberts","Apex Medical","609-445-2122"]

{"sheet":"Patient Notes","index":2,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,5,19,8],[0,0,0,4],[4,1,4,3],[7,5,7,8],[8,5,8,8],[14,5,14,8],[18,5,18,8],[15,5,15,8],[16,5,16,8],[17,5,17,8],[9,5,9,8],[10,5,10,8],[11,5,11,8],[12,5,12,8],[13,5,13,8]]}
["Willow Creek Physical Therapy"]
[]
[]
[]
[null,"Patient Notes"]
[]
[]
["ID #","Name","Diagnosis","Ailment","Exercises?","Notes/Comments"]
[1,"Austin Byron","03/21/1991","Back Pain","Assigned","Patient doing exercises 3X a week, good progress."]
[2,"Freddy Mercury","03/19/1956","Shoulder Pain","Assigned","Shoulder workouts going well, Heat before workout"]
[3,"Ricky Bobby","12/25/1978","Neck Pain","Assigned","Still thinks he is paralyzed"]
[4,"Jack Black","09/04/1978","Knee Surgery","Assigned","Won't stop playing his guitar even though it hurts his knee"]
[5,"Mr. Rogers","07/03/1958","Ankle Recovery","Assigned","Has made significant progress, 3-4 more weeks and send to outpatient"]
[6,"Jennifer Erickson","11/11/1998","Hip Pain","Assigned","Massage Therapy has made no significant progress"]
[7,"Scott  Merrill","09/12/1989","Knee Pain","Assigned","Knee strength up, stability still minimal"]
[8,"Brad Bishop","09/12/1976","TMJ Treatment","Not Assigned","Jaw clicking reduced, still experiencing many headaches"]
[9,"Erika Thompson","09/29/1987","Carpel Tunnel","Assigned","Patient is responding well to therapy"]
[10,"Amy Renton","06/12/1979","Back Pain","Assigned","Patient has been doing well"]
[11,"Robert Sanchez","09/23/1967","Neck Pain","Assigned","Patient Rocks!"]
[12,"Austin Allen","10/09/2000","Neck","Assigned"]

{"sheet":"Insurance","index":3,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[4,1,4,3]]}
["Willow Creek Physical Therapy"]
[]
[]
[]
[null,"Insurance Information"]
[]
[]
["Name","Insurance","Insurance Phone","Visits Covered","Visits Used"]
["Austin Byron","Aetna","808-889-5547",10]
["Freddy Mercury","Wave Ins","909-455-2311","13"]
["Ricky Bobby","Blue Cross","808-889-5547",15]
["Jack Black","Farm Med","789-554-9756",6]
["Mr. Rogers","Red Ins","808-889-5547",8]
["Jennifer Erickson","Black Ins","789-554-9756",10]
["Scott  Merrill","Insyoure","808-889-5547",22]
["Brad Bishop","Russia","789-554-9756",25]
["Erika Thompson","Green Ins","808-889-5547",30]
["Amy Renton","Insurance","789-554-9756",10]
["Robert Sanchez","Rocky MT","808-889-5547",10]
["Austin Allen","Valley Ins","801-223-9976",22]
["Rick James","Blue Cross","809-112-5564",25]

{"sheet":"Billing","index":4,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,1,4,3]]}
["Willow Creek Physical Therapy"]
[]
[null,null,null,"Size of Table:",10]
[]
[null,"Billing"]
[]
["ID #","Name","Phone","Address","Insurance","Doctor Office","Prescribed visits","Total Number of Visits","Amount Due","Amount Due(patient)","Amount Due(insurance)"]
[5,"Mr. Rogers","608-909-8897","123 Neighborhood Dr.","No","Dr. Abrams"]
[2,"Freddy Mercury","801-334-5543","1223 Crest Dr.","Yes","Dr. Christiansen"]
[8,"Brad Bishop","807-776-4537","334 Frost Ln.","Yes","Dr. Ferreiro"]
[6,"Jennifer Erickson","801-344-6789","344 Rocky Lane","Yes","Dr. Fonseca"]
[1,"Austin Byron","406-369-4554","2334 Crab Lane","Yes","Dr. Latu"]
[7,"Scott  Merrill","809-778-5798","210 Black Ln.","No","Dr. Mousely"]
[4,"Jack Black","801-556-6789","1234 D Lane","Yes","Dr. Richards"]
[3,"Ricky Bobby","408-334-8976","1223 Victory Lane","Yes","Dr. Woods"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Totals:",{"$f":"SUM($I$8:I18)","v":0},{"$f":"SUM($J$8:J18)","v":0},{"$f":"SUM($K$8:K18)","v":0}]

{"sheet":"EmployeeInfo","index":5,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,7],[4,0,4,2]]}
["Willow Creek Physical Therapy",null,null,null,null,null,null,null,"DPT-","Doctorate of Physical Therapy"]
[null,null,null,null,null,null,null,null,"CSCS-","Cert. Sports and Conditioning Specialist"]
[null,null,null,null,null,null,null,null,"CFS-","Craniofacial Specialist"]
[null,null,null,null,null,null,null,null,"MTC-","Manual Therapy Specialist"]
["Picture ID",null,null,"Name","Position","Degree","D.OB.","Phone","Address","Email","Employed on"]
[null,null,null,"Jeff Humphrey","Therapist","DPT,MTC,CFS","09/01/1973","406-257-85449","3342 Black Lane","jeff.humphrey@gmail.com","01/02/1990"]
[null,null,null,"Sky Pruitt","Therapist","DPT, CSCS","05/12/1981","406-990-5634","123 Red Lane","sky.pruitt@gmail.com","09/18/1997"]
[null,null,null,"Caren Stevens","Office Coordinator","N/A","11/11/1978","406-254-6391","554 Covey Tr.","caren.stevens@gmail.com","09/23/2000"]
[null,null,null,"Marcy Daly","Therapist","DPT","03/21/1982","406-961-4653","546 Triangle Ln.","marcy.daly@gmail.com","05/22/1999"]
[null,null,null,"Bridget Gardner","Therapy Aid","N/A","06/223/1986","405-342-7593","758 Hackerman Ln.","bridget.gardner@gmail.com","12/09/2001"]
[null,null,null,"Shawnie Stoker","Therapy Aid","N/A","08/30/1994","406-334-6983","312 Long Dr.","shawnie.stoker@gmail.com","03/12/2009"]
[null,null,null,"Candy Brown","Billing/Insurance","N/A","12/15/1979","406-264-9465","634 Blue Dr.","candy.brown@gmail.com","11/19/2000"]
[null,null,null,"Kristen Pound","Office Coord.","N/A","10/08/1987","406-963-1876","8675 Main St.","kristen.pound@gmail.com","08/12/2010"]

{"sheet":"Payroll","index":6,"n_rows":13,"n_cols":30,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Willow Creek Physical Therapy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mailed Check"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direct Deposit"]
[]
[]
[]
[]
[]
["Name","S.S. #","Address","Method of Payment","Bank","Account #","Hours","Wage","Total"]
["Jeff Humphrey","24323423","3342 Black Lane","","","",401,"10",4010]
[]
[]
[]
["","","","","",""]

{"sheet":"PaycheckArchive","index":7,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,7],[5,0,5,9]]}
["Willow Creek Physical Therapy"]
[]
[]
[]
[]
["Sent Paychecks - Archive"]
["Name","S.S. #","Address","Method of Payment","Bank","Account #","Hours","Wage","Total","Paycheck Date"]
["Jeff Humphrey","576356373","3342 Black Lane","Mailed Check","","","56","25",{"$f":"G8*H8","v":1400},"12/12/12"]
["Sky Pruitt","","123 Red Lane","Mailed Check","","","25","25",{"$f":"G9*H9","v":625},"12/12/12"]
["Caren Stevens","","554 Covey Tr.","Mailed Check","","","25","10",250,"12/12/12"]

{"sheet":"Notes","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}